{"statement":"SELECT\n                COUNTRY,\n                TAG_GROUP,\n                TAG_CATEGORY,\n                TAG_SUBCATEGORY,\n                TAG_TYPE,\n                TAG_BRAND,\n                TAG_SKU,\n                SUM(SALES * TAG_VOLUME)\n            FROM \n            table_a cf\n            INNER JOIN table_b pd ON cf.PRODUCT_ID = pd.ID\n            INNER JOIN table_c vd ON cf.VENUE_ID = vd.VENUE_ID\n            WHERE\n                TAG_GROUP = 'Drinks'\n                AND TAG_CATEGORY = 'Bier'\n                AND VENUE_CLUSTER IN (1, 2, 3, 4 , 5, 6, 7 , 8, 9, 10, 11)\n                AND COUNTRY = 'Netherlands'\n                AND EXCLUDE_FROM_BENCHMARK = FALSE\n                AND TAGS_CONFORMED_TO_HIERARCHY = TRUE\n                AND INCLUDED_IN_LIKE_FOR_LIKE = TRUE\n\t\tAND\n                    date_trunc('month', LOCAL_ORDERED_DATE )>= date_trunc('month', '2023-03-11') + INTERVAL 1 month\n                    AND date_trunc('month', LOCAL_ORDERED_DATE ) < date_trunc('year', '2023-03-11') + INTERVAL 1 year\n                    AND date_trunc('month', LOCAL_ORDERED_DATE )< date_trunc('month', '2023-06-11')\n\t            GROUP BY\n                COUNTRY,\n                TAG_GROUP,\n                TAG_CATEGORY,\n                TAG_SUBCATEGORY,\n                TAG_TYPE,\n                TAG_BRAND,\n                TAG_SKU;\n","table_meta":{"poc.table_a":"CREATE TABLE `table_a` (\n  `LOCAL_ORDERED_DATE` date NOT NULL COMMENT \"\",\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `PRODUCT_ID` int(11) NOT NULL COMMENT \"\",\n  `SALES` int(11) NOT NULL COMMENT \"\",\n  `REVENUE` float NOT NULL COMMENT \"\",\n  `REVENUE_WITHOUT_VAT` float NOT NULL COMMENT \"\",\n  `EXCLUDE_FROM_BENCHMARK` tinyint(4) NOT NULL COMMENT \"\",\n  INDEX idx_venue_id (`VENUE_ID`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`LOCAL_ORDERED_DATE`, `VENUE_ID`, `PRODUCT_ID`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`LOCAL_ORDERED_DATE`)\n(PARTITION p2000 VALUES [(\"2000-01-01\"), (\"2001-01-01\")),\nPARTITION p2001 VALUES [(\"2001-01-01\"), (\"2002-01-01\")),\nPARTITION p2002 VALUES [(\"2002-01-01\"), (\"2003-01-01\")),\nPARTITION p2003 VALUES [(\"2003-01-01\"), (\"2004-01-01\")),\nPARTITION p2004 VALUES [(\"2004-01-01\"), (\"2005-01-01\")),\nPARTITION p2005 VALUES [(\"2005-01-01\"), (\"2006-01-01\")),\nPARTITION p2006 VALUES [(\"2006-01-01\"), (\"2007-01-01\")),\nPARTITION p2007 VALUES [(\"2007-01-01\"), (\"2008-01-01\")),\nPARTITION p2008 VALUES [(\"2008-01-01\"), (\"2009-01-01\")),\nPARTITION p2009 VALUES [(\"2009-01-01\"), (\"2010-01-01\")),\nPARTITION p2010 VALUES [(\"2010-01-01\"), (\"2011-01-01\")),\nPARTITION p2011 VALUES [(\"2011-01-01\"), (\"2012-01-01\")),\nPARTITION p2012 VALUES [(\"2012-01-01\"), (\"2013-01-01\")),\nPARTITION p2013 VALUES [(\"2013-01-01\"), (\"2014-01-01\")),\nPARTITION p2014 VALUES [(\"2014-01-01\"), (\"2015-01-01\")),\nPARTITION p2015 VALUES [(\"2015-01-01\"), (\"2016-01-01\")),\nPARTITION p2016 VALUES [(\"2016-01-01\"), (\"2017-01-01\")),\nPARTITION p2017 VALUES [(\"2017-01-01\"), (\"2018-01-01\")),\nPARTITION p2018 VALUES [(\"2018-01-01\"), (\"2019-01-01\")),\nPARTITION p2019 VALUES [(\"2019-01-01\"), (\"2020-01-01\")),\nPARTITION p2020 VALUES [(\"2020-01-01\"), (\"2021-01-01\")),\nPARTITION p2021 VALUES [(\"2021-01-01\"), (\"2022-01-01\")),\nPARTITION p2022 VALUES [(\"2022-01-01\"), (\"2023-01-01\")),\nPARTITION p2023 VALUES [(\"2023-01-01\"), (\"2024-01-01\")),\nPARTITION p2024 VALUES [(\"2024-01-01\"), (\"2025-01-01\")),\nPARTITION p2025 VALUES [(\"2025-01-01\"), (\"2026-01-01\")),\nPARTITION p2026 VALUES [(\"2026-01-01\"), (\"2027-01-01\")),\nPARTITION p2027 VALUES [(\"2027-01-01\"), (\"2028-01-01\")),\nPARTITION p2028 VALUES [(\"2028-01-01\"), (\"2029-01-01\")),\nPARTITION p2029 VALUES [(\"2029-01-01\"), (\"2030-01-01\")),\nPARTITION p2030 VALUES [(\"2030-01-01\"), (\"2031-01-01\")),\nPARTITION p2031 VALUES [(\"2031-01-01\"), (\"2032-01-01\")),\nPARTITION p2032 VALUES [(\"2032-01-01\"), (\"2033-01-01\")),\nPARTITION p2033 VALUES [(\"2033-01-01\"), (\"2034-01-01\")),\nPARTITION p2034 VALUES [(\"2034-01-01\"), (\"2035-01-01\")),\nPARTITION p2035 VALUES [(\"2035-01-01\"), (\"2036-01-01\")),\nPARTITION p2036 VALUES [(\"2036-01-01\"), (\"2037-01-01\")),\nPARTITION p2037 VALUES [(\"2037-01-01\"), (\"2038-01-01\")),\nPARTITION p2038 VALUES [(\"2038-01-01\"), (\"2039-01-01\")),\nPARTITION p2039 VALUES [(\"2039-01-01\"), (\"2040-01-01\")),\nPARTITION p2040 VALUES [(\"2040-01-01\"), (\"2041-01-01\")),\nPARTITION p2041 VALUES [(\"2041-01-01\"), (\"2042-01-01\")),\nPARTITION p2042 VALUES [(\"2042-01-01\"), (\"2043-01-01\")),\nPARTITION p2043 VALUES [(\"2043-01-01\"), (\"2044-01-01\")),\nPARTITION p2044 VALUES [(\"2044-01-01\"), (\"2045-01-01\")),\nPARTITION p2045 VALUES [(\"2045-01-01\"), (\"2046-01-01\")),\nPARTITION p2046 VALUES [(\"2046-01-01\"), (\"2047-01-01\")),\nPARTITION p2047 VALUES [(\"2047-01-01\"), (\"2048-01-01\")),\nPARTITION p2048 VALUES [(\"2048-01-01\"), (\"2049-01-01\")),\nPARTITION p2049 VALUES [(\"2049-01-01\"), (\"2050-01-01\")),\nPARTITION p2050 VALUES [(\"2050-01-01\"), (\"2051-01-01\")),\nPARTITION p2051 VALUES [(\"2051-01-01\"), (\"2052-01-01\")),\nPARTITION p2052 VALUES [(\"2052-01-01\"), (\"2053-01-01\")),\nPARTITION p2053 VALUES [(\"2053-01-01\"), (\"2054-01-01\")),\nPARTITION p2054 VALUES [(\"2054-01-01\"), (\"2055-01-01\")),\nPARTITION p2055 VALUES [(\"2055-01-01\"), (\"2056-01-01\")),\nPARTITION p2056 VALUES [(\"2056-01-01\"), (\"2057-01-01\")),\nPARTITION p2057 VALUES [(\"2057-01-01\"), (\"2058-01-01\")),\nPARTITION p2058 VALUES [(\"2058-01-01\"), (\"2059-01-01\")),\nPARTITION p2059 VALUES [(\"2059-01-01\"), (\"2060-01-01\")),\nPARTITION p2060 VALUES [(\"2060-01-01\"), (\"2061-01-01\")),\nPARTITION p2061 VALUES [(\"2061-01-01\"), (\"2062-01-01\")),\nPARTITION p2062 VALUES [(\"2062-01-01\"), (\"2063-01-01\")),\nPARTITION p2063 VALUES [(\"2063-01-01\"), (\"2064-01-01\")),\nPARTITION p2064 VALUES [(\"2064-01-01\"), (\"2065-01-01\")),\nPARTITION p2065 VALUES [(\"2065-01-01\"), (\"2066-01-01\")),\nPARTITION p2066 VALUES [(\"2066-01-01\"), (\"2067-01-01\")),\nPARTITION p2067 VALUES [(\"2067-01-01\"), (\"2068-01-01\")),\nPARTITION p2068 VALUES [(\"2068-01-01\"), (\"2069-01-01\")),\nPARTITION p2069 VALUES [(\"2069-01-01\"), (\"2070-01-01\")),\nPARTITION p2070 VALUES [(\"2070-01-01\"), (\"2071-01-01\")),\nPARTITION p2071 VALUES [(\"2071-01-01\"), (\"2072-01-01\")),\nPARTITION p2072 VALUES [(\"2072-01-01\"), (\"2073-01-01\")),\nPARTITION p2073 VALUES [(\"2073-01-01\"), (\"2074-01-01\")),\nPARTITION p2074 VALUES [(\"2074-01-01\"), (\"2075-01-01\")),\nPARTITION p2075 VALUES [(\"2075-01-01\"), (\"2076-01-01\")),\nPARTITION p2076 VALUES [(\"2076-01-01\"), (\"2077-01-01\")),\nPARTITION p2077 VALUES [(\"2077-01-01\"), (\"2078-01-01\")),\nPARTITION p2078 VALUES [(\"2078-01-01\"), (\"2079-01-01\")),\nPARTITION p2079 VALUES [(\"2079-01-01\"), (\"2080-01-01\")),\nPARTITION p2080 VALUES [(\"2080-01-01\"), (\"2081-01-01\")),\nPARTITION p2081 VALUES [(\"2081-01-01\"), (\"2082-01-01\")),\nPARTITION p2082 VALUES [(\"2082-01-01\"), (\"2083-01-01\")),\nPARTITION p2083 VALUES [(\"2083-01-01\"), (\"2084-01-01\")),\nPARTITION p2084 VALUES [(\"2084-01-01\"), (\"2085-01-01\")),\nPARTITION p2085 VALUES [(\"2085-01-01\"), (\"2086-01-01\")),\nPARTITION p2086 VALUES [(\"2086-01-01\"), (\"2087-01-01\")),\nPARTITION p2087 VALUES [(\"2087-01-01\"), (\"2088-01-01\")),\nPARTITION p2088 VALUES [(\"2088-01-01\"), (\"2089-01-01\")),\nPARTITION p2089 VALUES [(\"2089-01-01\"), (\"2090-01-01\")),\nPARTITION p2090 VALUES [(\"2090-01-01\"), (\"2091-01-01\")),\nPARTITION p2091 VALUES [(\"2091-01-01\"), (\"2092-01-01\")),\nPARTITION p2092 VALUES [(\"2092-01-01\"), (\"2093-01-01\")),\nPARTITION p2093 VALUES [(\"2093-01-01\"), (\"2094-01-01\")),\nPARTITION p2094 VALUES [(\"2094-01-01\"), (\"2095-01-01\")),\nPARTITION p2095 VALUES [(\"2095-01-01\"), (\"2096-01-01\")),\nPARTITION p2096 VALUES [(\"2096-01-01\"), (\"2097-01-01\")),\nPARTITION p2097 VALUES [(\"2097-01-01\"), (\"2098-01-01\")),\nPARTITION p2098 VALUES [(\"2098-01-01\"), (\"2099-01-01\")),\nPARTITION p2099 VALUES [(\"2099-01-01\"), (\"2100-01-01\")),\nPARTITION p2100 VALUES [(\"2100-01-01\"), (\"2101-01-01\")))\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.table_b":"CREATE TABLE `table_b` (\n  `ID` int(11) NULL COMMENT \"\",\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `DESCRIPTION` varchar(300) NULL COMMENT \"\",\n  `UNIT_PRICE` int(11) NULL COMMENT \"\",\n  `TAG_GROUP` varchar(200) NULL COMMENT \"\",\n  `TAG_CATEGORY` varchar(200) NULL COMMENT \"\",\n  `TAG_SUBCATEGORY` varchar(200) NULL COMMENT \"\",\n  `TAG_BRAND` varchar(200) NULL COMMENT \"\",\n  `TAG_TYPE` varchar(200) NULL COMMENT \"\",\n  `TAG_MIXER_COMBINATION` varchar(200) NULL COMMENT \"\",\n  `TAG_CONTAINER` int(11) NULL COMMENT \"\",\n  `TAG_VOLUME` float NULL COMMENT \"\",\n  `TAG_SKU` varchar(200) NULL COMMENT \"\",\n  `CURRENT_ROW_INDICATOR` varchar(200) NULL COMMENT \"\",\n  `ROW_EFFECTIVE_DATE` date NULL COMMENT \"\",\n  `ROW_EXPIRATION_DATE` date NULL COMMENT \"\",\n  `LAST_CONFIRMED_BY_VENUE` datetime NULL COMMENT \"\",\n  `TAGGING_STATUS` varchar(255) NULL COMMENT \"\",\n  `TAG_SERVING_TYPE` varchar(255) NULL COMMENT \"\",\n  `TAG_ALCOHOL_PERCENTAGE` varchar(255) NULL COMMENT \"\",\n  `UNIQUE_PRODUCT_HASH` bigint(20) NULL COMMENT \"\",\n  `TAG_MEAL_POSITION` varchar(255) NULL COMMENT \"\",\n  `UNIT_PRICE_NO_VAT` int(11) NULL COMMENT \"\",\n  `VAT_TARIFF_PERCENT` int(11) NULL COMMENT \"\",\n  `LAST_TAG_UPDATE` datetime NULL COMMENT \"\",\n  `TAGS_CONFORMED_TO_HIERARCHY` varchar(255) NULL COMMENT \"\",\n  `READABLE_NAME` varchar(255) NULL COMMENT \"\",\n  `BRAND_OWNER` varchar(255) NULL COMMENT \"\",\n  `BRAND_PRODUCER` varchar(255) NULL COMMENT \"\",\n  `BRAND_DISTRIBUTOR` varchar(255) NULL COMMENT \"\",\n  `UNIQUE_INGREDIENT_HASH` bigint(20) NULL COMMENT \"\",\n  `PARENT_PRODUCT_NAME` varchar(255) NULL COMMENT \"\",\n  `SERVING_METHOD` varchar(255) NULL COMMENT \"\",\n  `HAS_ALCOHOL` varchar(255) NULL COMMENT \"\",\n  INDEX idx_id (`ID`) USING BITMAP,\n  INDEX idx_tag_group (`TAG_GROUP`) USING BITMAP,\n  INDEX idx_tag_category (`TAG_CATEGORY`) USING BITMAP,\n  INDEX idx_tags_conformed_to_hierarchy (`TAGS_CONFORMED_TO_HIERARCHY`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`ID`, `VENUE_ID`, `DESCRIPTION`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.table_c":"CREATE TABLE `table_c` (\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `PC6` varchar(255) NOT NULL COMMENT \"\",\n  `COUNTRY_PART` varchar(255) NOT NULL COMMENT \"\",\n  `PROVINCE` varchar(255) NOT NULL COMMENT \"\",\n  `COROP_PLUS_AREA` varchar(255) NULL COMMENT \"\",\n  `MUNICIPALITY` varchar(255) NULL COMMENT \"\",\n  `CITY_PART` varchar(255) NULL COMMENT \"\",\n  `CITY_PART_AREA` varchar(255) NULL COMMENT \"\",\n  `WIJK` varchar(255) NULL COMMENT \"\",\n  `BUURT` varchar(255) NULL COMMENT \"\",\n  `COUNTRY` varchar(255) NOT NULL COMMENT \"\",\n  `VENUE_CLUSTER` int(11) NOT NULL COMMENT \"\",\n  `MANUALLY_CHANGED` tinyint(4) NOT NULL COMMENT \"\",\n  `DEMO_VENUE` tinyint(4) NOT NULL COMMENT \"\",\n  `INCLUDED_IN_LIKE_FOR_LIKE` tinyint(4) NOT NULL COMMENT \"\",\n  INDEX idx_venue_id (`VENUE_ID`) USING BITMAP,\n  INDEX idx_country (`COUNTRY`) USING BITMAP,\n  INDEX idx_venue_cluster (`VENUE_CLUSTER`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`VENUE_ID`, `PC6`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.partition_flat_consumptions_partition":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition` (`COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `LOCAL_ORDERED_DATE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nPARTITION BY (date_trunc('year', `LOCAL_ORDERED_DATE`))\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"13600\")\nAS SELECT `vd`.`COUNTRY`, `vd`.`COUNTRY_PART`, `pd`.`TAG_GROUP`, `pd`.`TAG_CATEGORY`, `pd`.`TAG_SUBCATEGORY`, `pd`.`TAG_TYPE`, `pd`.`TAG_BRAND`, `pd`.`TAG_SKU`, `cf`.`SALES`, `pd`.`TAG_VOLUME`, `vd`.`VENUE_CLUSTER`, `cf`.`EXCLUDE_FROM_BENCHMARK`, `pd`.`TAGS_CONFORMED_TO_HIERARCHY`, `vd`.`INCLUDED_IN_LIKE_FOR_LIKE`, `cf`.`LOCAL_ORDERED_DATE`, `cf`.`REVENUE`, `pd`.`UNIT_PRICE`, `vd`.`PROVINCE`, `vd`.`VENUE_ID`, `pd`.`TAG_CONTAINER`, `vd`.`COROP_PLUS_AREA`\nFROM `poc`.`table_a` AS `cf` INNER JOIN `poc`.`table_b` AS `pd` ON `cf`.`PRODUCT_ID` = `pd`.`ID` INNER JOIN `poc`.`table_c` AS `vd` ON `cf`.`VENUE_ID` = `vd`.`VENUE_ID`;","poc.partition_flat_consumptions_partition_drinks":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nPARTITION BY (date_trunc('year', `LOCAL_ORDERED_DATE`))\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"13600\")\nAS SELECT `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition`.`COUNTRY`, `partition_flat_consumptions_partition`.`COUNTRY_PART`, `partition_flat_consumptions_partition`.`TAG_GROUP`, `partition_flat_consumptions_partition`.`TAG_CATEGORY`, `partition_flat_consumptions_partition`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition`.`TAG_TYPE`, `partition_flat_consumptions_partition`.`TAG_BRAND`, `partition_flat_consumptions_partition`.`TAG_SKU`, `partition_flat_consumptions_partition`.`SALES`, `partition_flat_consumptions_partition`.`TAG_VOLUME`, `partition_flat_consumptions_partition`.`VENUE_CLUSTER`, `partition_flat_consumptions_partition`.`EXCLUDE_FROM_BENCHMARK`, `partition_flat_consumptions_partition`.`TAGS_CONFORMED_TO_HIERARCHY`, `partition_flat_consumptions_partition`.`INCLUDED_IN_LIKE_FOR_LIKE`, `partition_flat_consumptions_partition`.`REVENUE`, `partition_flat_consumptions_partition`.`UNIT_PRICE`, `partition_flat_consumptions_partition`.`PROVINCE`, `partition_flat_consumptions_partition`.`VENUE_ID`, `partition_flat_consumptions_partition`.`TAG_CONTAINER`, `partition_flat_consumptions_partition`.`COROP_PLUS_AREA`\nFROM `poc`.`partition_flat_consumptions_partition`\nWHERE ((((((`partition_flat_consumptions_partition`.`TAG_GROUP` = 'Drinks') AND (`partition_flat_consumptions_partition`.`TAG_CATEGORY` = 'Bier')) AND (`partition_flat_consumptions_partition`.`VENUE_CLUSTER` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))) AND (`partition_flat_consumptions_partition`.`COUNTRY` = 'Netherlands')) AND (`partition_flat_consumptions_partition`.`EXCLUDE_FROM_BENCHMARK` = FALSE)) AND (`partition_flat_consumptions_partition`.`TAGS_CONFORMED_TO_HIERARCHY` = TRUE)) AND (`partition_flat_consumptions_partition`.`INCLUDED_IN_LIKE_FOR_LIKE` = TRUE);","poc.partition_flat_consumptions_partition_drinks_dates":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_dates` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nPARTITION BY (date_trunc('year', `LOCAL_ORDERED_DATE`))\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks`.`TAG_SKU`, sum(`partition_flat_consumptions_partition_drinks`.`SALES` * `partition_flat_consumptions_partition_drinks`.`TAG_VOLUME`) AS `total_volume`\nFROM `poc`.`partition_flat_consumptions_partition_drinks`\nGROUP BY `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks`.`TAG_SKU`, `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`;","poc.partition_flat_consumptions_partition_drinks_roll_year":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_roll_year` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('year', `partition_flat_consumptions_partition_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SKU`, sum(`partition_flat_consumptions_partition_drinks_dates`.`total_volume`) AS `total_volume`\nFROM `poc`.`partition_flat_consumptions_partition_drinks_dates`\nGROUP BY `partition_flat_consumptions_partition_drinks_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SKU`, date_trunc('year', `partition_flat_consumptions_partition_drinks_dates`.`LOCAL_ORDERED_DATE`);","poc.benchmark_mixers_consumptions_fact_daily_aggregate_large":"CREATE TABLE `benchmark_mixers_consumptions_fact_daily_aggregate_large` (\n  `LOCAL_ORDERED_DATE` date NOT NULL COMMENT \"\",\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `PRODUCT_ID` int(11) NOT NULL COMMENT \"\",\n  `SALES` int(11) NOT NULL COMMENT \"\",\n  `REVENUE` float NOT NULL COMMENT \"\",\n  `REVENUE_WITHOUT_VAT` float NOT NULL COMMENT \"\",\n  `EXCLUDE_FROM_BENCHMARK` tinyint(4) NOT NULL COMMENT \"\",\n  INDEX idx_venue_id (`VENUE_ID`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`LOCAL_ORDERED_DATE`, `VENUE_ID`, `PRODUCT_ID`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.flat_consumptions":"CREATE MATERIALIZED VIEW `flat_consumptions` (`COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `LOCAL_ORDERED_DATE`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"9223372036854775807\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `vd`.`COUNTRY`, `pd`.`TAG_GROUP`, `pd`.`TAG_CATEGORY`, `pd`.`TAG_SUBCATEGORY`, `pd`.`TAG_TYPE`, `pd`.`TAG_BRAND`, `pd`.`TAG_SKU`, `cf`.`SALES`, `pd`.`TAG_VOLUME`, `vd`.`VENUE_CLUSTER`, `cf`.`EXCLUDE_FROM_BENCHMARK`, `pd`.`TAGS_CONFORMED_TO_HIERARCHY`, `vd`.`INCLUDED_IN_LIKE_FOR_LIKE`, `cf`.`LOCAL_ORDERED_DATE`\nFROM `poc`.`benchmark_mixers_consumptions_fact_daily_aggregate_large` AS `cf` INNER JOIN `poc`.`table_b` AS `pd` ON `cf`.`PRODUCT_ID` = `pd`.`ID` INNER JOIN `poc`.`table_c` AS `vd` ON `cf`.`VENUE_ID` = `vd`.`VENUE_ID`;","poc.flat_consumptions_drinks":"CREATE MATERIALIZED VIEW `flat_consumptions_drinks` (`TAG_GROUP`, `TAG_CATEGORY`, `VENUE_CLUSTER`, `COUNTRY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `LOCAL_ORDERED_DATE`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT `flat_consumptions`.`TAG_GROUP`, `flat_consumptions`.`TAG_CATEGORY`, `flat_consumptions`.`VENUE_CLUSTER`, `flat_consumptions`.`COUNTRY`, `flat_consumptions`.`TAG_SUBCATEGORY`, `flat_consumptions`.`TAG_TYPE`, `flat_consumptions`.`TAG_BRAND`, `flat_consumptions`.`TAG_SKU`, `flat_consumptions`.`SALES`, `flat_consumptions`.`TAG_VOLUME`, `flat_consumptions`.`EXCLUDE_FROM_BENCHMARK`, `flat_consumptions`.`TAGS_CONFORMED_TO_HIERARCHY`, `flat_consumptions`.`INCLUDED_IN_LIKE_FOR_LIKE`, `flat_consumptions`.`LOCAL_ORDERED_DATE`\nFROM `poc`.`flat_consumptions`\nWHERE ((((((`flat_consumptions`.`TAG_GROUP` = 'Drinks') AND (`flat_consumptions`.`TAG_CATEGORY` = 'Bier')) AND (`flat_consumptions`.`VENUE_CLUSTER` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))) AND (`flat_consumptions`.`COUNTRY` = 'Netherlands')) AND (`flat_consumptions`.`EXCLUDE_FROM_BENCHMARK` = FALSE)) AND (`flat_consumptions`.`TAGS_CONFORMED_TO_HIERARCHY` = TRUE)) AND (`flat_consumptions`.`INCLUDED_IN_LIKE_FOR_LIKE` = TRUE);","poc.flat_consumptions_drinks_dates":"CREATE MATERIALIZED VIEW `flat_consumptions_drinks_dates` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `flat_consumptions_drinks`.`LOCAL_ORDERED_DATE`, `flat_consumptions_drinks`.`COUNTRY`, `flat_consumptions_drinks`.`TAG_GROUP`, `flat_consumptions_drinks`.`TAG_CATEGORY`, `flat_consumptions_drinks`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks`.`TAG_TYPE`, `flat_consumptions_drinks`.`TAG_BRAND`, `flat_consumptions_drinks`.`TAG_SKU`, sum(`flat_consumptions_drinks`.`SALES` * `flat_consumptions_drinks`.`TAG_VOLUME`) AS `total_volume`\nFROM `poc`.`flat_consumptions_drinks`\nGROUP BY `flat_consumptions_drinks`.`COUNTRY`, `flat_consumptions_drinks`.`TAG_GROUP`, `flat_consumptions_drinks`.`TAG_CATEGORY`, `flat_consumptions_drinks`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks`.`TAG_TYPE`, `flat_consumptions_drinks`.`TAG_BRAND`, `flat_consumptions_drinks`.`TAG_SKU`, `flat_consumptions_drinks`.`LOCAL_ORDERED_DATE`;","poc.flat_consumptions_drinks_dates_roll_year":"CREATE MATERIALIZED VIEW `flat_consumptions_drinks_dates_roll_year` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('year', `flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `flat_consumptions_drinks_dates`.`COUNTRY`, `flat_consumptions_drinks_dates`.`TAG_GROUP`, `flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks_dates`.`TAG_TYPE`, `flat_consumptions_drinks_dates`.`TAG_BRAND`, `flat_consumptions_drinks_dates`.`TAG_SKU`, sum(`flat_consumptions_drinks_dates`.`total_volume`) AS `total_volume`\nFROM `poc`.`flat_consumptions_drinks_dates`\nGROUP BY `flat_consumptions_drinks_dates`.`COUNTRY`, `flat_consumptions_drinks_dates`.`TAG_GROUP`, `flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks_dates`.`TAG_TYPE`, `flat_consumptions_drinks_dates`.`TAG_BRAND`, `flat_consumptions_drinks_dates`.`TAG_SKU`, date_trunc('year', `flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`);","poc.partition_flat_consumptions_partition_drinks_price":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_price` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nPARTITION BY (date_trunc('year', `LOCAL_ORDERED_DATE`))\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"13600\")\nAS SELECT `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks`.`TAG_SKU`, `partition_flat_consumptions_partition_drinks`.`SALES`, `partition_flat_consumptions_partition_drinks`.`TAG_VOLUME`, `partition_flat_consumptions_partition_drinks`.`VENUE_CLUSTER`, `partition_flat_consumptions_partition_drinks`.`EXCLUDE_FROM_BENCHMARK`, `partition_flat_consumptions_partition_drinks`.`TAGS_CONFORMED_TO_HIERARCHY`, `partition_flat_consumptions_partition_drinks`.`INCLUDED_IN_LIKE_FOR_LIKE`, `partition_flat_consumptions_partition_drinks`.`REVENUE`, `partition_flat_consumptions_partition_drinks`.`UNIT_PRICE`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`VENUE_ID`, `partition_flat_consumptions_partition_drinks`.`TAG_CONTAINER`, `partition_flat_consumptions_partition_drinks`.`COROP_PLUS_AREA`\nFROM `poc`.`partition_flat_consumptions_partition_drinks`\nWHERE (`partition_flat_consumptions_partition_drinks`.`UNIT_PRICE` > 0) AND (`partition_flat_consumptions_partition_drinks`.`UNIT_PRICE` IS NOT NULL);","poc.partition_flat_consumptions_partition_drinks_price_dates":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_price_dates` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `revenue`)\nCOMMENT \"MATERIALIZED_VIEW\"\nPARTITION BY (date_trunc('year', `LOCAL_ORDERED_DATE`))\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT `partition_flat_consumptions_partition_drinks_price`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks_price`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks_price`.`SALES` * `partition_flat_consumptions_partition_drinks_price`.`TAG_VOLUME`) AS `total_volume`, sum(`partition_flat_consumptions_partition_drinks_price`.`REVENUE`) AS `revenue`\nFROM `poc`.`partition_flat_consumptions_partition_drinks_price`\nGROUP BY `partition_flat_consumptions_partition_drinks_price`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks_price`.`LOCAL_ORDERED_DATE`;","poc.partition_flat_consumptions_partition_drinks_price_roll_year":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_price_roll_year` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `revenue`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('year', `partition_flat_consumptions_partition_drinks_price_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks_price_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks_price_dates`.`total_volume`) AS `total_volume`, sum(`partition_flat_consumptions_partition_drinks_price_dates`.`revenue`) AS `revenue`\nFROM `poc`.`partition_flat_consumptions_partition_drinks_price_dates`\nGROUP BY `partition_flat_consumptions_partition_drinks_price_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_CATEGORY`, date_trunc('year', `partition_flat_consumptions_partition_drinks_price_dates`.`LOCAL_ORDERED_DATE`);","poc.benchmark_mixers_consumptions_fact_daily_aggregate_small":"CREATE TABLE `benchmark_mixers_consumptions_fact_daily_aggregate_small` (\n  `LOCAL_ORDERED_DATE` date NOT NULL COMMENT \"\",\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `PRODUCT_ID` int(11) NOT NULL COMMENT \"\",\n  `SALES` int(11) NOT NULL COMMENT \"\",\n  `REVENUE` float NOT NULL COMMENT \"\",\n  `REVENUE_WITHOUT_VAT` float NOT NULL COMMENT \"\",\n  `EXCLUDE_FROM_BENCHMARK` tinyint(4) NOT NULL COMMENT \"\",\n  INDEX idx_venue_id (`VENUE_ID`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`LOCAL_ORDERED_DATE`, `VENUE_ID`, `PRODUCT_ID`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.partition_flat_consumptions_small":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_small` (`COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `LOCAL_ORDERED_DATE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `vd`.`COUNTRY`, `vd`.`COUNTRY_PART`, `pd`.`TAG_GROUP`, `pd`.`TAG_CATEGORY`, `pd`.`TAG_SUBCATEGORY`, `pd`.`TAG_TYPE`, `pd`.`TAG_BRAND`, `pd`.`TAG_SKU`, `cf`.`SALES`, `pd`.`TAG_VOLUME`, `vd`.`VENUE_CLUSTER`, `cf`.`EXCLUDE_FROM_BENCHMARK`, `pd`.`TAGS_CONFORMED_TO_HIERARCHY`, `vd`.`INCLUDED_IN_LIKE_FOR_LIKE`, `cf`.`LOCAL_ORDERED_DATE`, `cf`.`REVENUE`, `pd`.`UNIT_PRICE`, `vd`.`PROVINCE`, `vd`.`VENUE_ID`, `pd`.`TAG_CONTAINER`, `vd`.`COROP_PLUS_AREA`\nFROM `poc`.`benchmark_mixers_consumptions_fact_daily_aggregate_small` AS `cf` INNER JOIN `poc`.`table_b` AS `pd` ON `cf`.`PRODUCT_ID` = `pd`.`ID` INNER JOIN `poc`.`table_c` AS `vd` ON `cf`.`VENUE_ID` = `vd`.`VENUE_ID`;","poc.benchmark_mixers_consumptions_fact_daily_aggregate_medium":"CREATE TABLE `benchmark_mixers_consumptions_fact_daily_aggregate_medium` (\n  `LOCAL_ORDERED_DATE` date NOT NULL COMMENT \"\",\n  `VENUE_ID` int(11) NOT NULL COMMENT \"\",\n  `PRODUCT_ID` int(11) NOT NULL COMMENT \"\",\n  `SALES` int(11) NOT NULL COMMENT \"\",\n  `REVENUE` float NOT NULL COMMENT \"\",\n  `REVENUE_WITHOUT_VAT` float NOT NULL COMMENT \"\",\n  `EXCLUDE_FROM_BENCHMARK` tinyint(4) NOT NULL COMMENT \"\",\n  INDEX idx_venue_id (`VENUE_ID`) USING BITMAP,\n  INDEX idx_local_ordered_date (`LOCAL_ORDERED_DATE`) USING BITMAP\n) ENGINE=OLAP \nDUPLICATE KEY(`LOCAL_ORDERED_DATE`, `VENUE_ID`, `PRODUCT_ID`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`VENUE_ID`)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);","poc.m_flat_consumptions":"CREATE MATERIALIZED VIEW `m_flat_consumptions` (`COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `LOCAL_ORDERED_DATE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"13600\")\nAS SELECT `vd`.`COUNTRY`, `vd`.`COUNTRY_PART`, `pd`.`TAG_GROUP`, `pd`.`TAG_CATEGORY`, `pd`.`TAG_SUBCATEGORY`, `pd`.`TAG_TYPE`, `pd`.`TAG_BRAND`, `pd`.`TAG_SKU`, `cf`.`SALES`, `pd`.`TAG_VOLUME`, `vd`.`VENUE_CLUSTER`, `cf`.`EXCLUDE_FROM_BENCHMARK`, `pd`.`TAGS_CONFORMED_TO_HIERARCHY`, `vd`.`INCLUDED_IN_LIKE_FOR_LIKE`, `cf`.`LOCAL_ORDERED_DATE`, `cf`.`REVENUE`, `pd`.`UNIT_PRICE`, `vd`.`PROVINCE`, `vd`.`VENUE_ID`, `pd`.`TAG_CONTAINER`, `vd`.`COROP_PLUS_AREA`\nFROM `poc`.`benchmark_mixers_consumptions_fact_daily_aggregate_medium` AS `cf` INNER JOIN `poc`.`table_b` AS `pd` ON `cf`.`PRODUCT_ID` = `pd`.`ID` INNER JOIN `poc`.`table_c` AS `vd` ON `cf`.`VENUE_ID` = `vd`.`VENUE_ID`;","poc.m_flat_consumptions_drinks":"CREATE MATERIALIZED VIEW `m_flat_consumptions_drinks` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"13600\")\nAS SELECT `m_flat_consumptions`.`LOCAL_ORDERED_DATE`, `m_flat_consumptions`.`COUNTRY`, `m_flat_consumptions`.`COUNTRY_PART`, `m_flat_consumptions`.`TAG_GROUP`, `m_flat_consumptions`.`TAG_CATEGORY`, `m_flat_consumptions`.`TAG_SUBCATEGORY`, `m_flat_consumptions`.`TAG_TYPE`, `m_flat_consumptions`.`TAG_BRAND`, `m_flat_consumptions`.`TAG_SKU`, `m_flat_consumptions`.`SALES`, `m_flat_consumptions`.`TAG_VOLUME`, `m_flat_consumptions`.`VENUE_CLUSTER`, `m_flat_consumptions`.`EXCLUDE_FROM_BENCHMARK`, `m_flat_consumptions`.`TAGS_CONFORMED_TO_HIERARCHY`, `m_flat_consumptions`.`INCLUDED_IN_LIKE_FOR_LIKE`, `m_flat_consumptions`.`REVENUE`, `m_flat_consumptions`.`UNIT_PRICE`, `m_flat_consumptions`.`PROVINCE`, `m_flat_consumptions`.`VENUE_ID`, `m_flat_consumptions`.`TAG_CONTAINER`, `m_flat_consumptions`.`COROP_PLUS_AREA`\nFROM `poc`.`m_flat_consumptions`\nWHERE (((((`m_flat_consumptions`.`TAG_GROUP` = 'Drinks') AND (`m_flat_consumptions`.`VENUE_CLUSTER` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))) AND (`m_flat_consumptions`.`COUNTRY` = 'Netherlands')) AND (`m_flat_consumptions`.`EXCLUDE_FROM_BENCHMARK` = FALSE)) AND (`m_flat_consumptions`.`TAGS_CONFORMED_TO_HIERARCHY` = TRUE)) AND (`m_flat_consumptions`.`INCLUDED_IN_LIKE_FOR_LIKE` = TRUE);","poc.partition_flat_consumptions_partition_drinks_venue_rollup_date":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_venue_rollup_date` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `PROVINCE`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `bitmap_agg(VENUE_ID)`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks`.`SALES` * `partition_flat_consumptions_partition_drinks`.`TAG_VOLUME`) AS `total_volume`, bitmap_agg(`partition_flat_consumptions_partition_drinks`.`VENUE_ID`) AS `bitmap_agg(VENUE_ID)`\nFROM `poc`.`partition_flat_consumptions_partition_drinks`\nGROUP BY `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`;","poc.partition_flat_consumptions_drink_selector":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_drink_selector` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT `partition_flat_consumptions_small`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_small`.`COUNTRY`, `partition_flat_consumptions_small`.`COUNTRY_PART`, `partition_flat_consumptions_small`.`TAG_GROUP`, `partition_flat_consumptions_small`.`TAG_CATEGORY`, `partition_flat_consumptions_small`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_small`.`TAG_TYPE`, `partition_flat_consumptions_small`.`TAG_BRAND`, `partition_flat_consumptions_small`.`TAG_SKU`, `partition_flat_consumptions_small`.`SALES`, `partition_flat_consumptions_small`.`TAG_VOLUME`, `partition_flat_consumptions_small`.`VENUE_CLUSTER`, `partition_flat_consumptions_small`.`EXCLUDE_FROM_BENCHMARK`, `partition_flat_consumptions_small`.`TAGS_CONFORMED_TO_HIERARCHY`, `partition_flat_consumptions_small`.`INCLUDED_IN_LIKE_FOR_LIKE`, `partition_flat_consumptions_small`.`REVENUE`, `partition_flat_consumptions_small`.`UNIT_PRICE`, `partition_flat_consumptions_small`.`PROVINCE`, `partition_flat_consumptions_small`.`VENUE_ID`, `partition_flat_consumptions_small`.`TAG_CONTAINER`, `partition_flat_consumptions_small`.`COROP_PLUS_AREA`\nFROM `poc`.`partition_flat_consumptions_small`\nWHERE ((((((`partition_flat_consumptions_small`.`TAG_GROUP` = 'Drinks') AND (`partition_flat_consumptions_small`.`TAG_CATEGORY` = 'Bier')) AND (`partition_flat_consumptions_small`.`VENUE_CLUSTER` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))) AND (`partition_flat_consumptions_small`.`COUNTRY` = 'Netherlands')) AND (`partition_flat_consumptions_small`.`EXCLUDE_FROM_BENCHMARK` = FALSE)) AND (`partition_flat_consumptions_small`.`TAGS_CONFORMED_TO_HIERARCHY` = TRUE)) AND (`partition_flat_consumptions_small`.`INCLUDED_IN_LIKE_FOR_LIKE` = TRUE);","poc.m_flat_consumptions_drinks_dates":"CREATE MATERIALIZED VIEW `m_flat_consumptions_drinks_dates` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`, `revenue`, `UNIT_PRICE`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `m_flat_consumptions_drinks`.`LOCAL_ORDERED_DATE`, `m_flat_consumptions_drinks`.`COUNTRY`, `m_flat_consumptions_drinks`.`TAG_GROUP`, `m_flat_consumptions_drinks`.`TAG_CATEGORY`, `m_flat_consumptions_drinks`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks`.`TAG_TYPE`, `m_flat_consumptions_drinks`.`TAG_BRAND`, `m_flat_consumptions_drinks`.`TAG_SKU`, sum(`m_flat_consumptions_drinks`.`REVENUE`) AS `revenue`, `m_flat_consumptions_drinks`.`UNIT_PRICE`, sum(`m_flat_consumptions_drinks`.`SALES` * `m_flat_consumptions_drinks`.`TAG_VOLUME`) AS `total_volume`\nFROM `poc`.`m_flat_consumptions_drinks`\nGROUP BY `m_flat_consumptions_drinks`.`COUNTRY`, `m_flat_consumptions_drinks`.`TAG_GROUP`, `m_flat_consumptions_drinks`.`TAG_CATEGORY`, `m_flat_consumptions_drinks`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks`.`TAG_TYPE`, `m_flat_consumptions_drinks`.`TAG_BRAND`, `m_flat_consumptions_drinks`.`TAG_SKU`, `m_flat_consumptions_drinks`.`LOCAL_ORDERED_DATE`, `m_flat_consumptions_drinks`.`UNIT_PRICE`;","poc.partition_flat_consumptions_partition_drinks_roll_month":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_roll_month` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('month', `partition_flat_consumptions_partition_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SKU`, sum(`partition_flat_consumptions_partition_drinks_dates`.`total_volume`) AS `total_volume`\nFROM `poc`.`partition_flat_consumptions_partition_drinks_dates`\nGROUP BY `partition_flat_consumptions_partition_drinks_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_CATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_TYPE`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_BRAND`, `partition_flat_consumptions_partition_drinks_dates`.`TAG_SKU`, date_trunc('month', `partition_flat_consumptions_partition_drinks_dates`.`LOCAL_ORDERED_DATE`);","poc.flat_consumptions_drinks_dates_roll_month":"CREATE MATERIALIZED VIEW `flat_consumptions_drinks_dates_roll_month` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('month', `flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `flat_consumptions_drinks_dates`.`COUNTRY`, `flat_consumptions_drinks_dates`.`TAG_GROUP`, `flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks_dates`.`TAG_TYPE`, `flat_consumptions_drinks_dates`.`TAG_BRAND`, `flat_consumptions_drinks_dates`.`TAG_SKU`, sum(`flat_consumptions_drinks_dates`.`total_volume`) AS `total_volume`\nFROM `poc`.`flat_consumptions_drinks_dates`\nGROUP BY `flat_consumptions_drinks_dates`.`COUNTRY`, `flat_consumptions_drinks_dates`.`TAG_GROUP`, `flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `flat_consumptions_drinks_dates`.`TAG_TYPE`, `flat_consumptions_drinks_dates`.`TAG_BRAND`, `flat_consumptions_drinks_dates`.`TAG_SKU`, date_trunc('month', `flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`);","poc.partition_flat_consumptions_partition_drinks_price_roll_month":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_price_roll_month` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `revenue`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('month', `partition_flat_consumptions_partition_drinks_price_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks_price_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks_price_dates`.`total_volume`) AS `total_volume`, sum(`partition_flat_consumptions_partition_drinks_price_dates`.`revenue`) AS `revenue`\nFROM `poc`.`partition_flat_consumptions_partition_drinks_price_dates`\nGROUP BY `partition_flat_consumptions_partition_drinks_price_dates`.`COUNTRY`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks_price_dates`.`TAG_CATEGORY`, date_trunc('month', `partition_flat_consumptions_partition_drinks_price_dates`.`LOCAL_ORDERED_DATE`);","poc.partition_flat_consumptions_partition_venue_roll_date":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_venue_roll_date` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `approxVenueCount`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition`.`COUNTRY`, bitmap_agg(`partition_flat_consumptions_partition`.`VENUE_ID`) AS `approxVenueCount`\nFROM `poc`.`partition_flat_consumptions_partition`\nWHERE `partition_flat_consumptions_partition`.`COROP_PLUS_AREA` = 'Amsterdam'\nGROUP BY `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition`.`COUNTRY`;","poc.partition_flat_consumptions_partition_venue_roll_month":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_venue_roll_month` (`date_trunc('month', LOCAL_ORDERED_DATE)`, `COUNTRY`, `approxVenueCount`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT date_trunc('month', `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`) AS `date_trunc('month', LOCAL_ORDERED_DATE)`, `partition_flat_consumptions_partition`.`COUNTRY`, bitmap_agg(`partition_flat_consumptions_partition`.`VENUE_ID`) AS `approxVenueCount`\nFROM `poc`.`partition_flat_consumptions_partition`\nWHERE `partition_flat_consumptions_partition`.`COROP_PLUS_AREA` = 'Amsterdam'\nGROUP BY date_trunc('month', `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`), `partition_flat_consumptions_partition`.`COUNTRY`;","poc.m_flat_consumptions_drinks_dates_roll_month":"CREATE MATERIALIZED VIEW `m_flat_consumptions_drinks_dates_roll_month` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`, `revenue`, `UNIT_PRICE`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('month', `m_flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `m_flat_consumptions_drinks_dates`.`COUNTRY`, `m_flat_consumptions_drinks_dates`.`TAG_GROUP`, `m_flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_TYPE`, `m_flat_consumptions_drinks_dates`.`TAG_BRAND`, `m_flat_consumptions_drinks_dates`.`TAG_SKU`, sum(`m_flat_consumptions_drinks_dates`.`total_volume`) AS `total_volume`, sum(`m_flat_consumptions_drinks_dates`.`revenue`) AS `revenue`, `m_flat_consumptions_drinks_dates`.`UNIT_PRICE`\nFROM `poc`.`m_flat_consumptions_drinks_dates`\nGROUP BY `m_flat_consumptions_drinks_dates`.`COUNTRY`, `m_flat_consumptions_drinks_dates`.`TAG_GROUP`, `m_flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_TYPE`, `m_flat_consumptions_drinks_dates`.`TAG_BRAND`, `m_flat_consumptions_drinks_dates`.`TAG_SKU`, date_trunc('month', `m_flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`), `m_flat_consumptions_drinks_dates`.`UNIT_PRICE`;","poc.new_partition_flat_consumptions_drink_selector":"CREATE MATERIALIZED VIEW `new_partition_flat_consumptions_drink_selector` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `SALES`, `TAG_VOLUME`, `VENUE_CLUSTER`, `EXCLUDE_FROM_BENCHMARK`, `TAGS_CONFORMED_TO_HIERARCHY`, `INCLUDED_IN_LIKE_FOR_LIKE`, `REVENUE`, `UNIT_PRICE`, `PROVINCE`, `VENUE_ID`, `TAG_CONTAINER`, `COROP_PLUS_AREA`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT `partition_flat_consumptions_small`.`LOCAL_ORDERED_DATE`, `partition_flat_consumptions_small`.`COUNTRY`, `partition_flat_consumptions_small`.`COUNTRY_PART`, `partition_flat_consumptions_small`.`TAG_GROUP`, `partition_flat_consumptions_small`.`TAG_CATEGORY`, `partition_flat_consumptions_small`.`TAG_SUBCATEGORY`, `partition_flat_consumptions_small`.`TAG_TYPE`, `partition_flat_consumptions_small`.`TAG_BRAND`, `partition_flat_consumptions_small`.`TAG_SKU`, `partition_flat_consumptions_small`.`SALES`, `partition_flat_consumptions_small`.`TAG_VOLUME`, `partition_flat_consumptions_small`.`VENUE_CLUSTER`, `partition_flat_consumptions_small`.`EXCLUDE_FROM_BENCHMARK`, `partition_flat_consumptions_small`.`TAGS_CONFORMED_TO_HIERARCHY`, `partition_flat_consumptions_small`.`INCLUDED_IN_LIKE_FOR_LIKE`, `partition_flat_consumptions_small`.`REVENUE`, `partition_flat_consumptions_small`.`UNIT_PRICE`, `partition_flat_consumptions_small`.`PROVINCE`, `partition_flat_consumptions_small`.`VENUE_ID`, `partition_flat_consumptions_small`.`TAG_CONTAINER`, `partition_flat_consumptions_small`.`COROP_PLUS_AREA`\nFROM `poc`.`partition_flat_consumptions_small`\nWHERE (((((`partition_flat_consumptions_small`.`TAG_GROUP` = 'Drinks') AND (`partition_flat_consumptions_small`.`VENUE_CLUSTER` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))) AND (`partition_flat_consumptions_small`.`COUNTRY` = 'Netherlands')) AND (`partition_flat_consumptions_small`.`EXCLUDE_FROM_BENCHMARK` = FALSE)) AND (`partition_flat_consumptions_small`.`TAGS_CONFORMED_TO_HIERARCHY` = TRUE)) AND (`partition_flat_consumptions_small`.`INCLUDED_IN_LIKE_FOR_LIKE` = TRUE);","poc.partition_flat_consumptions_partition_venue_roll_year":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_venue_roll_year` (`date_trunc('year', LOCAL_ORDERED_DATE)`, `COUNTRY`, `approxVenueCount`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT date_trunc('year', `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`) AS `date_trunc('year', LOCAL_ORDERED_DATE)`, `partition_flat_consumptions_partition`.`COUNTRY`, bitmap_agg(`partition_flat_consumptions_partition`.`VENUE_ID`) AS `approxVenueCount`\nFROM `poc`.`partition_flat_consumptions_partition`\nWHERE `partition_flat_consumptions_partition`.`COROP_PLUS_AREA` = 'Amsterdam'\nGROUP BY date_trunc('year', `partition_flat_consumptions_partition`.`LOCAL_ORDERED_DATE`), `partition_flat_consumptions_partition`.`COUNTRY`;","poc.m_flat_consumptions_drinks_dates_roll_year":"CREATE MATERIALIZED VIEW `m_flat_consumptions_drinks_dates_roll_year` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `TAG_GROUP`, `TAG_CATEGORY`, `TAG_SUBCATEGORY`, `TAG_TYPE`, `TAG_BRAND`, `TAG_SKU`, `total_volume`, `revenue`, `UNIT_PRICE`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\")\nAS SELECT date_trunc('year', `m_flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `m_flat_consumptions_drinks_dates`.`COUNTRY`, `m_flat_consumptions_drinks_dates`.`TAG_GROUP`, `m_flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_TYPE`, `m_flat_consumptions_drinks_dates`.`TAG_BRAND`, `m_flat_consumptions_drinks_dates`.`TAG_SKU`, sum(`m_flat_consumptions_drinks_dates`.`total_volume`) AS `total_volume`, sum(`m_flat_consumptions_drinks_dates`.`revenue`) AS ` revenue`, `m_flat_consumptions_drinks_dates`.`UNIT_PRICE`\nFROM `poc`.`m_flat_consumptions_drinks_dates`\nGROUP BY `m_flat_consumptions_drinks_dates`.`COUNTRY`, `m_flat_consumptions_drinks_dates`.`TAG_GROUP`, `m_flat_consumptions_drinks_dates`.`TAG_CATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_SUBCATEGORY`, `m_flat_consumptions_drinks_dates`.`TAG_TYPE`, `m_flat_consumptions_drinks_dates`.`TAG_BRAND`, `m_flat_consumptions_drinks_dates`.`TAG_SKU`, `m_flat_consumptions_drinks_dates`.`UNIT_PRICE`, date_trunc('year', `m_flat_consumptions_drinks_dates`.`LOCAL_ORDERED_DATE`);","poc.partition_flat_consumptions_partition_drinks_venue_rollup_month":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_venue_rollup_month` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `PROVINCE`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `bitmap_agg(VENUE_ID)`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT date_trunc('month', `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks`.`SALES` * `partition_flat_consumptions_partition_drinks`.`TAG_VOLUME`) AS `total_volume`, bitmap_agg(`partition_flat_consumptions_partition_drinks`.`VENUE_ID`) AS `bitmap_agg(VENUE_ID)`\nFROM `poc`.`partition_flat_consumptions_partition_drinks`\nGROUP BY `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, date_trunc('month', `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`);","poc.partition_flat_consumptions_partition_drinks_venue_rollup_year":"CREATE MATERIALIZED VIEW `partition_flat_consumptions_partition_drinks_venue_rollup_year` (`LOCAL_ORDERED_DATE`, `COUNTRY`, `COUNTRY_PART`, `PROVINCE`, `TAG_GROUP`, `TAG_CATEGORY`, `total_volume`, `bitmap_agg(VENUE_ID)`)\nCOMMENT \"MATERIALIZED_VIEW\"\nDISTRIBUTED BY RANDOM\nREFRESH MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"replication_num\" = \"1\",\n\"session.sql_select_limit\" = \"0\",\n\"session.query_timeout\" = \"3600\")\nAS SELECT date_trunc('year', `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`) AS `LOCAL_ORDERED_DATE`, `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, sum(`partition_flat_consumptions_partition_drinks`.`SALES` * `partition_flat_consumptions_partition_drinks`.`TAG_VOLUME`) AS `total_volume`, bitmap_agg(`partition_flat_consumptions_partition_drinks`.`VENUE_ID`) AS `bitmap_agg(VENUE_ID)`\nFROM `poc`.`partition_flat_consumptions_partition_drinks`\nGROUP BY `partition_flat_consumptions_partition_drinks`.`COUNTRY`, `partition_flat_consumptions_partition_drinks`.`COUNTRY_PART`, `partition_flat_consumptions_partition_drinks`.`PROVINCE`, `partition_flat_consumptions_partition_drinks`.`TAG_GROUP`, `partition_flat_consumptions_partition_drinks`.`TAG_CATEGORY`, date_trunc('year', `partition_flat_consumptions_partition_drinks`.`LOCAL_ORDERED_DATE`);"},"table_row_count":{"poc.partition_flat_consumptions_partition":{"p2023_2024":67432301},"poc.table_a":{"p2023":76989874},"poc.partition_flat_consumptions_partition_drinks_dates":{"p2023_2024":368599},"poc.table_b":{"table_b":9417292},"poc.partition_flat_consumptions_partition_drinks":{"p2023_2024":3152614},"poc.partition_flat_consumptions_partition_drinks_roll_month":{"partition_flat_consumptions_partition_drinks_roll_month":2720435},"poc.table_c":{"table_c":5754}},"column_statistics":{"poc.partition_flat_consumptions_partition":{"TAGS_CONFORMED_TO_HIERARCHY":"[-Infinity, Infinity, 0.02386, 1.0E-5, 3.0] ESTIMATE","TAG_CATEGORY":"[-Infinity, Infinity, 0.23905, 0.00136, 16.0] ESTIMATE","TAG_VOLUME":"[0.0, 1.8, 0.0, 8.0, 84.0] ESTIMATE","INCLUDED_IN_LIKE_FOR_LIKE":"[0.0, 1.0, 0.0, 1.0, 2.0] ESTIMATE","EXCLUDE_FROM_BENCHMARK":"[0.0, 1.0, 0.0, 1.0, 2.0] ESTIMATE","TAG_SUBCATEGORY":"[-Infinity, Infinity, 0.335605, 0.00417, 90.0] ESTIMATE","TAG_SKU":"[-Infinity, Infinity, 0.526185, 0.100605, 1557.0] ESTIMATE","COUNTRY":"[-Infinity, Infinity, 0.0, 5.5E-5, 1.0] ESTIMATE","VENUE_CLUSTER":"[1.0, 118.0, 0.0, 4.0, 30.0] ESTIMATE","LOCAL_ORDERED_DATE":"[1.2623328E9, 1.2650976E9, 0.0, 4.0, 33.0] ESTIMATE","TAG_GROUP":"[-Infinity, Infinity, 7.85E-4, 1.6E-4, 5.0] ESTIMATE","SALES":"[1.0, 14762.0, 0.0, 4.0, 385.0] ESTIMATE","TAG_TYPE":"[-Infinity, Infinity, 0.36898, 0.01822, 371.0] ESTIMATE","TAG_BRAND":"[-Infinity, Infinity, 0.63749, 0.05218, 1090.0] ESTIMATE"},"poc.table_a":{"VENUE_ID":"[12.0, 12160.0, 0.0, 4.0, 2.784374E7] ESTIMATE","LOCAL_ORDERED_DATE":"[9.467136E8, 9.789408E8, 0.0, 4.0, 9.0] ESTIMATE","PRODUCT_ID":"[6343337.0, 2.81363518E8, 0.0, 4.0, 96971.0] ESTIMATE","SALES":"[1.0, 12411.0, 0.0, 4.0, 430.0] ESTIMATE","EXCLUDE_FROM_BENCHMARK":"[0.0, 1.0, 0.0, 1.0, 2.0] ESTIMATE"},"poc.partition_flat_consumptions_partition_drinks_dates":{"TAG_SUBCATEGORY":"[-Infinity, Infinity, 0.0010038008784614173, 11.224555682462514, 6.0] ESTIMATE","total_volume":"[0.0, 18812.720052540302, 0.0, 8.0, 39074.0] ESTIMATE","TAG_SKU":"[-Infinity, Infinity, 0.07836971885436476, 10.748382388449237, 1848.0] ESTIMATE","COUNTRY":"[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE","TAG_CATEGORY":"[-Infinity, Infinity, 0.0, 4.0, 1.0] ESTIMATE","LOCAL_ORDERED_DATE":"[9.467136E8, 4.1339232E9, 0.0, 4.0, 37025.0] ESTIMATE","TAG_GROUP":"[-Infinity, Infinity, 0.0, 6.0, 1.0] ESTIMATE","TAG_TYPE":"[-Infinity, Infinity, 0.0260798320125665, 5.828510115328582, 24.0] ESTIMATE","TAG_BRAND":"[-Infinity, Infinity, 0.03056166728612937, 9.602714603132402, 658.0] ESTIMATE"},"poc.table_b":{"TAG_SUBCATEGORY":"[-Infinity, Infinity, 0.505899041890174, 4.445678014444067, 92.0] ESTIMATE","TAGS_CONFORMED_TO_HIERARCHY":"[-Infinity, Infinity, 0.16735596602505265, 0.8326440339749474, 2.0] ESTIMATE","TAG_SKU":"[-Infinity, Infinity, 0.7093860952808939, 3.1399554139342816, 7290.0] ESTIMATE","TAG_CATEGORY":"[-Infinity, Infinity, 0.4126316779813135, 8.467412818886789, 16.0] ESTIMATE","TAG_VOLUME":"[0.0, 135.0, 0.0, 8.0, 260.0] ESTIMATE","ID":"[6288802.0, 2.81178386E8, 0.0, 4.0, 8962232.0] ESTIMATE","TAG_GROUP":"[-Infinity, Infinity, 0.003082627150140401, 5.014660583955558, 5.0] ESTIMATE","TAG_BRAND":"[-Infinity, Infinity, 0.7478060571977592, 2.4488907214515594, 3196.0] ESTIMATE","TAG_TYPE":"[-Infinity, Infinity, 0.5421046729781768, 4.138268198543701, 433.0] ESTIMATE"},"poc.partition_flat_consumptions_partition_drinks":{"TAG_SUBCATEGORY":"[-Infinity, Infinity, 0.0020633670979066897, 9.184868810453802, 6.0] ESTIMATE","TAG_SKU":"[-Infinity, Infinity, 0.023504939075954114, 9.391695272557946, 1848.0] ESTIMATE","COUNTRY":"[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE","TAG_CATEGORY":"[-Infinity, Infinity, 0.0, 4.0, 1.0] ESTIMATE","TAG_VOLUME":"[0.0, 1.5, 0.0, 8.0, 40.0] ESTIMATE","LOCAL_ORDERED_DATE":"[9.467136E8, 4.1339232E9, 0.0, 4.0, 37025.0] ESTIMATE","TAG_GROUP":"[-Infinity, Infinity, 0.0, 6.0, 1.0] ESTIMATE","SALES":"[1.0, 12551.0, 0.0, 4.0, 1413.0] ESTIMATE","TAG_TYPE":"[-Infinity, Infinity, 0.008757494574343704, 5.496174603043697, 24.0] ESTIMATE","TAG_BRAND":"[-Infinity, Infinity, 0.016956405065764475, 8.502326957883204, 658.0] ESTIMATE"},"poc.partition_flat_consumptions_partition_drinks_roll_month":{"TAG_SUBCATEGORY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","total_volume":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","TAG_SKU":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","COUNTRY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","TAG_CATEGORY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","LOCAL_ORDERED_DATE":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","TAG_GROUP":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","TAG_TYPE":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN","TAG_BRAND":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"},"poc.table_c":{"VENUE_ID":"[7.0, 12212.0, 0.0, 4.0, 5717.0] ESTIMATE","COUNTRY":"[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE","VENUE_CLUSTER":"[1.0, 118.0, 0.0, 4.0, 30.0] ESTIMATE","INCLUDED_IN_LIKE_FOR_LIKE":"[0.0, 1.0, 0.0, 1.0, 2.0] ESTIMATE"}},"explain_info":"PLAN FRAGMENT 0(F02)\n  Output Exprs:52 | 12 | 13 | 14 | 16: TAG_TYPE | 15: TAG_BRAND | 20: TAG_SKU | 58: sum\n  Input Partition: UNPARTITIONED\n  RESULT SINK\n\n  6:EXCHANGE\n     cardinality: 1055\n\nPLAN FRAGMENT 1(F01)\n\n  Input Partition: HASH_PARTITIONED: 396: COUNTRY, 397: TAG_GROUP, 398: TAG_CATEGORY, 395: TAG_SUBCATEGORY, 16: TAG_TYPE, 15: TAG_BRAND, 20: TAG_SKU\n  OutPut Partition: UNPARTITIONED\n  OutPut Exchange Id: 06\n\n  5:Decode\n  |  <dict id 395> : <string id 14>\n  |  <dict id 396> : <string id 52>\n  |  <dict id 397> : <string id 12>\n  |  <dict id 398> : <string id 13>\n  |  cardinality: 1055\n  |  column statistics: \n  |  * TAG_GROUP-->[-Infinity, Infinity, 0.0, 5.014660583955558, 5.0] ESTIMATE\n  |  * TAG_CATEGORY-->[-Infinity, Infinity, 0.0, 8.467412818886789, 16.0] ESTIMATE\n  |  * TAG_SUBCATEGORY-->[-Infinity, Infinity, 0.010752688172043012, 4.445678014444067, 92.0] ESTIMATE\n  |  * TAG_BRAND-->[-Infinity, Infinity, 9.470593806231652E-4, 2.4488907214515594, 1054.8999999999999] ESTIMATE\n  |  * TAG_TYPE-->[-Infinity, Infinity, 0.002304147465437788, 4.138268198543701, 433.0] ESTIMATE\n  |  * TAG_SKU-->[-Infinity, Infinity, 9.470593806231652E-4, 3.1399554139342816, 1054.8999999999999] ESTIMATE\n  |  * COUNTRY-->[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE\n  |  * sum-->[0.0, 4110393.3174418597, 0.0, 8.0, 430.0] ESTIMATE\n  |  \n  4:AGGREGATE (merge finalize)\n  |  aggregate: sum[([58: sum, DOUBLE, true]); args: DOUBLE; result: DOUBLE; args nullable: true; result nullable: true]\n  |  group by: [396: COUNTRY, INT, false], [397: TAG_GROUP, INT, true], [398: TAG_CATEGORY, INT, true], [395: TAG_SUBCATEGORY, INT, true], [16: TAG_TYPE, VARCHAR, true], [15: TAG_BRAND, VARCHAR, true], [20: TAG_SKU, VARCHAR, true]\n  |  cardinality: 1055\n  |  column statistics: \n  |  * TAG_GROUP-->[-Infinity, Infinity, 0.0, 5.014660583955558, 5.0] ESTIMATE\n  |  * TAG_CATEGORY-->[-Infinity, Infinity, 0.0, 8.467412818886789, 16.0] ESTIMATE\n  |  * TAG_SUBCATEGORY-->[-Infinity, Infinity, 0.010752688172043012, 4.445678014444067, 92.0] ESTIMATE\n  |  * TAG_BRAND-->[-Infinity, Infinity, 9.470593806231652E-4, 2.4488907214515594, 1054.8999999999999] ESTIMATE\n  |  * TAG_TYPE-->[-Infinity, Infinity, 0.002304147465437788, 4.138268198543701, 433.0] ESTIMATE\n  |  * TAG_SKU-->[-Infinity, Infinity, 9.470593806231652E-4, 3.1399554139342816, 1054.8999999999999] ESTIMATE\n  |  * COUNTRY-->[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE\n  |  * sum-->[0.0, 4110393.3174418597, 0.0, 8.0, 430.0] ESTIMATE\n  |  \n  3:EXCHANGE\n     distribution type: SHUFFLE\n     partition exprs: [396: COUNTRY, INT, false], [397: TAG_GROUP, INT, true], [398: TAG_CATEGORY, INT, true], [395: TAG_SUBCATEGORY, INT, true], [16: TAG_TYPE, VARCHAR, true], [15: TAG_BRAND, VARCHAR, true], [20: TAG_SKU, VARCHAR, true]\n     cardinality: 1055\n\nPLAN FRAGMENT 2(F00)\n\n  Input Partition: RANDOM\n  OutPut Partition: HASH_PARTITIONED: 396: COUNTRY, 397: TAG_GROUP, 398: TAG_CATEGORY, 395: TAG_SUBCATEGORY, 16: TAG_TYPE, 15: TAG_BRAND, 20: TAG_SKU\n  OutPut Exchange Id: 03\n\n  2:AGGREGATE (update serialize)\n  |  STREAMING\n  |  aggregate: sum[([57: expr, DOUBLE, true]); args: DOUBLE; result: DOUBLE; args nullable: true; result nullable: true]\n  |  group by: [396: COUNTRY, INT, false], [397: TAG_GROUP, INT, true], [398: TAG_CATEGORY, INT, true], [395: TAG_SUBCATEGORY, INT, true], [16: TAG_TYPE, VARCHAR, true], [15: TAG_BRAND, VARCHAR, true], [20: TAG_SKU, VARCHAR, true]\n  |  cardinality: 1055\n  |  column statistics: \n  |  * TAG_GROUP-->[-Infinity, Infinity, 0.0, 5.014660583955558, 5.0] ESTIMATE\n  |  * TAG_CATEGORY-->[-Infinity, Infinity, 0.0, 8.467412818886789, 16.0] ESTIMATE\n  |  * TAG_SUBCATEGORY-->[-Infinity, Infinity, 0.010752688172043012, 4.445678014444067, 92.0] ESTIMATE\n  |  * TAG_BRAND-->[-Infinity, Infinity, 9.470593806231652E-4, 2.4488907214515594, 1054.8999999999999] ESTIMATE\n  |  * TAG_TYPE-->[-Infinity, Infinity, 0.002304147465437788, 4.138268198543701, 433.0] ESTIMATE\n  |  * TAG_SKU-->[-Infinity, Infinity, 9.470593806231652E-4, 3.1399554139342816, 1054.8999999999999] ESTIMATE\n  |  * COUNTRY-->[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE\n  |  * sum-->[0.0, 4110393.3174418597, 0.0, 8.0, 430.0] ESTIMATE\n  |  \n  1:Project\n  |  output columns:\n  |  15 <-> [370: TAG_BRAND, VARCHAR, true]\n  |  16 <-> [369: TAG_TYPE, VARCHAR, true]\n  |  20 <-> [371: TAG_SKU, VARCHAR, true]\n  |  57 <-> cast([372: SALES, INT, false] as DOUBLE) * cast([373: TAG_VOLUME, FLOAT, true] as DOUBLE)\n  |  395 <-> [395: TAG_SUBCATEGORY, INT, true]\n  |  396 <-> [396: COUNTRY, INT, false]\n  |  397 <-> [397: TAG_GROUP, INT, true]\n  |  398 <-> [398: TAG_CATEGORY, INT, true]\n  |  cardinality: 1055\n  |  column statistics: \n  |  * TAG_BRAND-->[-Infinity, Infinity, 0.7478060571977592, 2.4488907214515594, 1054.8999999999999] ESTIMATE\n  |  * TAG_TYPE-->[-Infinity, Infinity, 0.5421046729781768, 4.138268198543701, 433.0] ESTIMATE\n  |  * TAG_SKU-->[-Infinity, Infinity, 0.7093860952808939, 3.1399554139342816, 1054.8999999999999] ESTIMATE\n  |  * expr-->[0.0, 1675485.0, 0.0, 8.0, 430.0] ESTIMATE\n  |  \n  0:OlapScanNode\n     table: partition_flat_consumptions_partition, rollup: partition_flat_consumptions_partition\n     preAggregation: on\n     Predicates: DictExpr(397: TAG_GROUP,[<place-holder> = 'Drinks']), DictExpr(398: TAG_CATEGORY,[<place-holder> = 'Bier']), DictExpr(396: COUNTRY,[<place-holder> = 'Netherlands']), [377: INCLUDED_IN_LIKE_FOR_LIKE, TINYINT, false] = 1, [375: EXCLUDE_FROM_BENCHMARK, TINYINT, false] = 0, cast([376: TAGS_CONFORMED_TO_HIERARCHY, VARCHAR, true] as DOUBLE) = 1.0, date_trunc[('month', [363: LOCAL_ORDERED_DATE, DATE, false]); args: VARCHAR,DATE; result: DATE; args nullable: false; result nullable: true] >= '2023-04-01', date_trunc[('month', [363: LOCAL_ORDERED_DATE, DATE, false]); args: VARCHAR,DATE; result: DATE; args nullable: false; result nullable: true] <= '2023-05-31', 374: VENUE_CLUSTER IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)\n     dict_col=TAG_SUBCATEGORY,COUNTRY,TAG_GROUP,TAG_CATEGORY\n     partitionsRatio=1/101, tabletsRatio=25/25\n     tabletList=35302,35303,35304,35305,35306,35307,35308,35309,35310,35311 ...\n     actualRows=67432301, avgRowSize=66.65487\n     MaterializedView: true\n     cardinality: 1055\n     column statistics: \n     * VENUE_ID-->[12.0, 12160.0, 0.0, 4.0, 1054.8999999999999] ESTIMATE\n     * SALES-->[1.0, 12411.0, 0.0, 4.0, 430.0] ESTIMATE\n     * TAG_GROUP-->[-Infinity, Infinity, 0.0, 5.014660583955558, 5.0] ESTIMATE\n     * TAG_CATEGORY-->[-Infinity, Infinity, 0.0, 8.467412818886789, 16.0] ESTIMATE\n     * TAG_SUBCATEGORY-->[-Infinity, Infinity, 0.505899041890174, 4.445678014444067, 92.0] ESTIMATE\n     * TAG_BRAND-->[-Infinity, Infinity, 0.7478060571977592, 2.4488907214515594, 1054.8999999999999] ESTIMATE\n     * TAG_TYPE-->[-Infinity, Infinity, 0.5421046729781768, 4.138268198543701, 433.0] ESTIMATE\n     * TAG_VOLUME-->[0.0, 135.0, 0.0, 8.0, 260.0] ESTIMATE\n     * TAG_SKU-->[-Infinity, Infinity, 0.7093860952808939, 3.1399554139342816, 1054.8999999999999] ESTIMATE\n     * VENUE_ID-->[12.0, 12160.0, 0.0, 4.0, 1054.8999999999999] ESTIMATE\n     * COUNTRY-->[-Infinity, Infinity, 0.0, 11.0, 1.0] ESTIMATE\n     * expr-->[0.0, 1675485.0, 0.0, 8.0, 430.0] ESTIMATE\n","session_variables":"{\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"enable_hive_metadata_cache_with_insert\":false,\"hive_temp_staging_dir\":\"/tmp/starrocks\",\"cbo_cte_reuse_rate_v2\":1.15,\"character_set_results\":\"utf8\",\"enable_count_star_optimization\":true,\"enable_iceberg_column_statistics\":true,\"thrift_plan_protocol\":\"binary\",\"enable_plan_serialize_concurrently\":true,\"global_runtime_filter_build_min_size\":131072,\"enable_iceberg_identity_column_optimize\":true,\"enable_view_based_mv_rewrite\":false,\"query_excluding_mv_names\":\"\",\"enable_rewrite_simple_agg_to_meta_scan\":false,\"enable_adaptive_sink_dop\":true,\"consistent_hash_virtual_number\":32,\"warehouse\":\"default_warehouse\",\"enable_profile\":false,\"load_mem_limit\":0,\"cbo_eq_base_type\":\"varchar\",\"enable_materialized_view_for_insert\":false,\"large_decimal_underlying_type\":\"panic\",\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"disable_function_fold_constants\":false,\"enable_query_queue\":true,\"select_ratio_threshold\":0.15,\"query_delivery_timeout\":300,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"follower_query_forward_mode\":\"\",\"cbo_use_lock_db\":false,\"new_planner_agg_stage\":0,\"enable_strict_order_by\":true,\"hash_join_interpolate_passthrough\":false,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"enable_rewrite_bitmap_union_to_bitamp_agg\":true,\"resource_group\":\"\",\"enable_materialized_view_plan_cache\":true,\"spill_operator_max_bytes\":1048576000,\"cbo_max_reorder_node_use_dp\":10,\"enable_hive_column_stats\":true,\"enable_async_profile\":true,\"enable_groupby_use_output_alias\":false,\"global_runtime_filter_wait_timeout\":20,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"cross_join_cost_penalty\":1000000,\"query_cache_agg_cardinality_limit\":5000000,\"cboPushDownAggregateMode_v1\":1,\"window_partition_mode\":1,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":false,\"enable_incremental_mv\":false,\"cbo_push_down_topn_limit\":1000,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"materialized_view_rewrite_mode\":\"DEFAULT\",\"enable_read_iceberg_puffin_ndv\":true,\"enable_write_hive_external_table\":false,\"enable_simplify_case_when\":true,\"runtime_join_filter_push_down_limit\":1024000,\"trace_log_mode\":\"command\",\"enable_scan_datacache\":false,\"big_query_log_cpu_second_threshold\":480,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"enable_short_circuit\":false,\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"prefer_cte_rewrite\":false,\"optimizer_materialized_view_timelimit\":1000,\"hdfs_backend_selector_scan_range_shuffle\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"hive_partition_stats_sample_size\":3000,\"enable_mv_planner\":false,\"enable_collect_table_level_scan_stats\":true,\"enable_populate_datacache\":true,\"query_debug_options\":\"\",\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"spill_encode_level\":7,\"enable_query_dump\":false,\"global_runtime_filter_build_max_size\":67108864,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"connector_io_tasks_per_scan_operator\":4,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_materialized_view_rewrite_partition_compensate\":true,\"enable_exchange_pass_through\":true,\"runtime_profile_report_interval\":10,\"query_cache_entry_max_bytes\":4194304,\"enable_partition_column_value_only_optimization\":true,\"interleaving_group_size\":10,\"enable_exchange_perf\":false,\"enable_prepare_stmt\":true,\"workgroup_id\":0,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"cbo_decimal_cast_string_strict\":true,\"cbo_enable_predicate_subfield_path\":true,\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"spill_mode\":\"auto\",\"enable_query_debug_trace\":false,\"enable_show_all_variables\":false,\"full_sort_max_buffered_bytes\":16777216,\"wait_timeout\":28800,\"max_buckets_per_be_to_use_balancer_assignment\":6,\"enable_query_tablet_affinity\":false,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"global_runtime_filter_rpc_http_min_size\":67108864,\"cbo_materialized_view_rewrite_rule_output_limit\":3,\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":3000,\"enable_outer_join_reorder\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"cbo_enable_greedy_join_reorder\":true,\"range_pruner_max_predicate\":100,\"enable_rbo_table_prune\":false,\"spillable_operator_mask\":-1,\"rpc_http_min_size\":2147482624,\"enable_file_metacache\":false,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_cbo_table_prune\":false,\"enable_parallel_merge\":true,\"cbo_materialized_view_rewrite_candidate_limit\":12,\"cbo_derive_join_is_null_predicate\":true,\"nested_mv_rewrite_max_level\":10,\"big_query_profile_threshold\":\"0s\",\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"spill_revocable_max_bytes\":0,\"hash_join_push_down_right_table\":true,\"pipeline_sink_dop\":0,\"broadcast_row_limit\":15000000,\"enable_prune_iceberg_manifest\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"global_runtime_filter_rpc_timeout\":400,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"full_sort_max_buffered_rows\":1024000,\"query_timeout\":500,\"connector_io_tasks_slow_io_latency_ms\":50,\"cbo_max_reorder_node\":50,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"enable_sync_materialized_view_rewrite\":true,\"prefer_compute_node\":false,\"enable_strict_type\":false,\"group_concat_max_len\":1024,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"enable_prune_complex_types_in_unnest\":true,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"enable_per_bucket_optimize\":true,\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"connector_sink_compression_codec\":\"uncompressed\",\"storage_engine\":\"olap\",\"spill_operator_min_bytes\":52428800,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"materialized_view_join_same_table_permutation_limit\":5,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"enable_spill\":false,\"enable_materialized_view_rewrite_greedy_mode\":false,\"pipeline_dop\":1,\"single_node_exec_plan\":false,\"full_sort_late_materialization_v2\":true,\"join_implementation_mode_v2\":\"auto\",\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"hdfs_backend_selector_hash_algorithm\":\"consistent\",\"enable_expr_prune_partition\":true,\"enable_topn_runtime_filter\":true,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"skew_join_rand_range\":1000,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_predicate_reorder\":false,\"enable_query_cache\":false,\"transaction_read_only\":\"OFF\",\"max_allowed_packet\":33554432,\"time_zone\":\"America/Los_Angeles\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"audit_execute_stmt\":false,\"cbo_derive_range_join_predicate\":false,\"allow_default_partition\":false,\"paimon_force_jni_reader\":false,\"enable_pipeline_level_shuffle\":true}","be_number":17,"be_core_stat":{"numOfHardwareCoresPerBe":"{\"21160\":8,\"73491\":8,\"73490\":8,\"73493\":8,\"73492\":8,\"10006\":16,\"73495\":8,\"10007\":8,\"73494\":8,\"73497\":8,\"73496\":8,\"73499\":8,\"73498\":8,\"73501\":8,\"73500\":8,\"73503\":8,\"73502\":8}","cachedAvgNumOfHardwareCores":-1},"exception":[" ate_trunc('year not be desensitized"],"version":"3.2.3-ee-0131","commit_version":"4adf529"}